Skip to main content

Snowflake Billing Export Integration with nOps Business Context+

FAQs

Expand FAQs

1. What data does nOps collect from Snowflake?

nOps leverages three key Snowflake system tables to provide comprehensive insights:

SNOWFLAKE.ORGANIZATION_USAGE.WAREHOUSE_METERING_HISTORY

  • Returns hourly credit usage for Virtual Warehouse and Cloud Services
  • Tracks credit consumption per warehouse
  • Data retained for one year
  • Helps understand warehouse-level resource utilization and costs

SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY

  • Provides detailed query performance metrics
  • Includes total elapsed time, warehouse used, data bytes scanned
  • Comprehensive view of query efficiency and resource consumption
  • Data retained for one year
  • Enables deep analysis of computational workloads

SNOWFLAKE.ORGANIZATION_USAGE.USAGE_IN_CURRENCY_DAILY

  • Daily credit usage in currency format
  • Tracks organizational-level spending
  • Facilitates precise cost allocation and budgeting

2. Why enable Snowflake Billing Exports?

  • Gain comprehensive visibility into your Snowflake resource consumption
  • Track detailed usage and associated costs
  • Optimize cloud spending through granular insights
  • Align cloud expenses with business objectives

3. Is my Snowflake data secure with nOps?

  • nOps uses read-only access with minimal required permissions
  • Secure, encrypted data transmission
  • No direct access to sensitive operational data
  • Complies with best practices for cloud integration security

Setting Up the Integration

Integration Scope Warning

Important: Only a single integration should be created from the organization admin account. The ORGANIZATION_USAGE views return identical data across all accounts, as they reflect usage at the organization level.
Setting up multiple integrations from different accounts in the same organization will cause data duplication and inconsistent reporting.
Ensure that only one account — the org admin — is used to integrate with nOps.

To integrate Snowflake Billing Exports with nOps Business Context+, follow these comprehensive steps.


1. Why Use nOps for Snowflake Cost Management?

  • Unified Cost Visibility – Consolidate Snowflake spend with other cloud platform costs
  • Automated Cost Analysis – Identify inefficiencies in Snowflake resource utilization
  • Granular Insights – Understand query performance, warehouse usage, and cost drivers
  • Optimization Recommendations – Receive actionable suggestions to reduce Snowflake expenses

2. Prerequisites for Integration

Before connecting Snowflake to nOps, ensure you have:

  • ACCOUNTADMIN privileges in your Snowflake account
  • You must be logged into the organization admin account, as Snowflake ORGANIZATION_USAGE views are only accessible from it
  • Network connectivity to nOps platform
  • Snowflake account identifier and region information
  • Ability to create databases, roles, and users

3. Integration Benefits

  • Comprehensive Reporting – Generate detailed Snowflake cost and usage reports
  • Performance Tracking – Monitor query efficiency and resource consumption
  • Budget Alignment – Map Snowflake expenses to specific business units or projects
  • Continuous Optimization – Receive ongoing recommendations for cost reduction
note

Integrating Snowflake with nOps BC+ transforms raw usage data into strategic insights, enabling more informed cloud spending decisions.

Next Steps

Start Snowflake Integration Setup